Question 1

What is a regular expression that matches all of the following headers?

MEDICATIONS ON ADMISSION:

Medications on Admission:

MEDICATIONS:

Medications:

medications:

ADMISSIONS MEDICATIONS:

CURRENT MEDICATIONS:

Medication:

medication:

MEDICATION:

CURRENT MEDICATION ON ADMISSION:

ADMISSION MEDICATION:

Current medications:

MEDICATION ON ADMISSION:

Question 2

Using the radiology reports in Google BigQuery try to create a regular expression that matches only "cyst" or "cystic". What is one words that is a potential mismatch for simple searches for cyst and cystic?

Question 3

Using the radiology reports in Google BigQuery, how many notes have the words diverticula, diverticulitis, or diverticulosis?

Question 4

Using the discharge summary notes in Google BigQuery `course4_data.discharge_summaries`, how many notes have the word "hypertension" in them?

Question 5

Using the discharge summary notes in Google BigQuery `course4_data.discharge_summaries`, how many notes have the phrase "blood pressure" in them?

Question 6

Using the radiology reports in Google BigQuery, what is the maximum number of uses of the word diverticula, diverticulitis, or diverticulosis in a single note?

Question 7

Using the discharge summary notes in Google BigQuery `course4_data.discharge_summaries`, what is the maximum number of uses of the word "hypertension" in a single note?

Question 8

Using the discharge summary notes in Google BigQuery `course4_data.discharge_summaries`, what is the maximum number of uses of the phrase "blood pressure" in a single note?

Question 9

Using the radiology reports in Google BigQuery, replace the headers used in Note 1 that have an extra space at the beginning of the line ("REASON FOR EXAM:", "COMPARISON:", "TECHNIQUE", "CT ABDOMEN:", and "CT PELVIS:") with the same headers without the space.

Question 10

Using the discharge summary notes in Google BigQuery `course4_data.discharge_summaries`, replace the section headers "CLINCAL RESUME:", "CURRENT HISTORY:", "BRIEF HISTORY:", "HISTORY AND PHYSICAL:", and "BRIEF HISTORY AND PHYSICAL:" with "HISTORY OF PRESENT ILLNESS:"